/***********************************************************
* Purpose : Get one Question by id and status
* Author : DATDT
* Date: 25/3/2012
* Description: Get one Question by id and status
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_GetOneQuestionbyID_Status') 
BEGIN
	DROP PROC sp_GetOneQuestionbyID_Status
END
GO
CREATE PROC sp_GetOneQuestionbyID_Status
	@ID INTEGER
AS
BEGIN
	SELECT * FROM Question where ID = @ID and Status = 0
END